<?php

class ViewRaidPlayersTable extends Doctrine_Table
{
    public function getGuilded()
    {
        return $this
            ->createQuery('a')
            ->where("guildedflag=?", 1)
            ->andWhere("( talentmainspec=? or talentactive=? or talentactive IS NULL )", array(1, 1))
            ->addOrderBy("talentmainspec");
    }

    public function retrieveActiveRaidPlayer(Doctrine_Query $q)
    {
        $q->addWhere("guilded=?", 1);
    }
}